|
|||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||
java.lang.Object | +--com.northgateis.reality.realsql.RealSQLDatabaseMetaData
The RealSQLDatabaseMetaData class is an implementation of the JDBC 2.0 DatabaseMetaData interface.
DatabaseMetaData,
Connection.getMetaData()| Constructor Summary | |
RealSQLDatabaseMetaData(RealSQLConnection con,
int traceFlags)
Constructs a new DatabaseMetaData object which maybe used to extract driver and database specific information. |
|
| Method Summary | |
boolean |
allProceduresAreCallable()
Can all the procedures returned by getProcedures be called by the current user? |
boolean |
allTablesAreSelectable()
Can all the tables returned by getTable be SELECTed by the current user? |
boolean |
dataDefinitionCausesTransactionCommit()
Does a data definition statement within a transaction force the transaction to commit? |
boolean |
dataDefinitionIgnoredInTransactions()
Is a data definition statement within a transaction ignored? |
boolean |
deletesAreDetected(int type)
JDBC 2.0 Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted(). |
boolean |
doesMaxRowSizeIncludeBlobs()
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs? |
protected void |
finalize()
Ensures that the statement resources at the server are released if this object is garbage collected without a prior call to the close method. |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
int scope,
boolean nullable)
Gets a description of a table's optimal set of columns that uniquely identifies a row. |
java.sql.ResultSet |
getCatalogs()
Gets the catalog names available in this database. |
java.lang.String |
getCatalogSeparator()
What's the separator between catalog and table name? |
java.lang.String |
getCatalogTerm()
What's the database vendor's preferred term for "catalog"? |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String ct,
java.lang.String sch,
java.lang.String tn,
java.lang.String cn)
Not supported by the RealSQL-JDBC driver. |
java.sql.ResultSet |
getColumns(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
java.lang.String columnName)
Gets a description of table columns available in the specified catalog. |
java.sql.Connection |
getConnection()
JDBC 2.0 Retrieves the connection that produced this metadata object. |
java.sql.ResultSet |
getCrossReference(java.lang.String pcat,
java.lang.String pschem,
java.lang.String ptable,
java.lang.String fcat,
java.lang.String fschem,
java.lang.String ftable)
Not supported by the RealSQL-JDBC driver. |
java.lang.String |
getDatabaseProductName()
Get the name of this database product? |
java.lang.String |
getDatabaseProductVersion()
Get the version of this database product? |
int |
getDefaultTransactionIsolation()
What's the database's default transaction isolation level? The values are defined in java.sql.Connection. |
int |
getDriverMajorVersion()
Get the JDBC driver's major version number? |
int |
getDriverMinorVersion()
Get the JDBC driver's minor version number? |
java.lang.String |
getDriverName()
Get the name of this JDBC driver? |
java.lang.String |
getDriverVersion()
What's the version of this JDBC driver? |
java.sql.ResultSet |
getExportedKeys(java.lang.String ct,
java.lang.String sch,
java.lang.String t)
Not supported by the RealSQL-JDBC driver. |
java.lang.String |
getExtraNameCharacters()
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). |
java.lang.String |
getIdentifierQuoteString()
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported. |
java.sql.ResultSet |
getImportedKeys(java.lang.String ct,
java.lang.String sch,
java.lang.String t)
Not supported by the RealSQL-JDBC driver. |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
boolean unique,
boolean approximate)
Gets a description of a table's indices and statistics. |
int |
getMaxBinaryLiteralLength()
How many hex characters can you have in an inline binary literal? |
int |
getMaxCatalogNameLength()
What's the maximum length of a catalog name? |
int |
getMaxCharLiteralLength()
What's the max length for a character literal? |
int |
getMaxColumnNameLength()
What's the limit on column name length? |
int |
getMaxColumnsInGroupBy()
What's the maximum number of columns in a "GROUP BY" clause? |
int |
getMaxColumnsInIndex()
What's the maximum number of columns allowed in an index? |
int |
getMaxColumnsInOrderBy()
What's the maximum number of columns in an "ORDER BY" clause? |
int |
getMaxColumnsInSelect()
What's the maximum number of columns in a "SELECT" list? |
int |
getMaxColumnsInTable()
What's the maximum number of columns in a table? |
int |
getMaxConnections()
How many active connections can we have at a time to this database? |
int |
getMaxCursorNameLength()
What's the maximum cursor name length? |
int |
getMaxIndexLength()
What's the maximum length of an index (in bytes)? |
int |
getMaxProcedureNameLength()
What's the maximum length of a procedure name? |
int |
getMaxRowSize()
What's the maximum length of a single row? |
int |
getMaxSchemaNameLength()
What's the maximum length allowed for a schema name? |
int |
getMaxStatementLength()
What's the maximum length of a SQL statement? |
int |
getMaxStatements()
How many active statements can we have open at one time to this database? |
int |
getMaxTableNameLength()
What's the maximum length of a table name? |
int |
getMaxTablesInSelect()
What's the maximum number of tables in a SELECT statement? |
int |
getMaxUserNameLength()
What's the maximum length of a user name? |
java.lang.String |
getNumericFunctions()
Gets a comma-separated list of math functions. |
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName)
Gets a description of a table's primary key columns. |
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
Not supported by the RealSQL-JDBC driver. |
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
Not supported by the RealSQL-JDBC driver. |
java.lang.String |
getProcedureTerm()
What's the database vendor's preferred term for "procedure"? |
java.sql.ResultSet |
getSchemas()
Gets the schema names available in this database. |
java.lang.String |
getSchemaTerm()
What's the database vendor's preferred term for "schema"? |
java.lang.String |
getSearchStringEscape()
Gets the string that can be used to escape wildcard characters. |
java.lang.String |
getSQLKeywords()
Gets a comma-separated list of all a database's SQL keywords that are NOT also SQL92 keywords. |
java.lang.String |
getStringFunctions()
Gets a comma-separated list of string functions. |
java.lang.String |
getSystemFunctions()
Gets a comma-separated list of system functions. |
java.sql.ResultSet |
getTablePrivileges(java.lang.String ct,
java.lang.String sch,
java.lang.String tn)
Not supported by the RealSQL-JDBC driver. |
java.sql.ResultSet |
getTables(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
java.lang.String[] types)
Gets a description of tables available in a catalog. |
java.sql.ResultSet |
getTableTypes()
Gets the table types available in this database. |
java.lang.String |
getTimeDateFunctions()
Gets a comma-separated list of system functions. |
java.sql.ResultSet |
getTypeInfo()
Gets a description of all the standard SQL types supported by this . |
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schema,
java.lang.String tn,
int[] types)
Not supported by the RealSQL-JDBC driver. |
java.lang.String |
getURL()
Get the url for this database? |
java.lang.String |
getUserName()
Get our user name as known to the database? |
java.sql.ResultSet |
getVersionColumns(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName)
Gets a description of a table's columns that are automatically updated when any value in a row is updated. |
boolean |
insertsAreDetected(int type)
JDBC 2.0 Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted(). |
boolean |
isCatalogAtStart()
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end) |
boolean |
isReadOnly()
Is the database in read-only mode? |
boolean |
nullPlusNonNullIsNull()
Are concatenations between NULL and non-NULL values NULL? A JDBC CompliantTM driver always returns true. |
boolean |
nullsAreSortedAtEnd()
Are NULL values sorted at the end regardless of sort order? |
boolean |
nullsAreSortedAtStart()
Are NULL values sorted at the start regardlass of sort order? |
boolean |
nullsAreSortedHigh()
Are NULL values sorted high? |
boolean |
nullsAreSortedLow()
Are NULL values sorted low? |
boolean |
othersDeletesAreVisible(int type)
JDBC 2.0 Indicates whether deletes made by others are visible. |
boolean |
othersInsertsAreVisible(int type)
JDBC 2.0 Indicates whether inserts made by others are visible. |
boolean |
othersUpdatesAreVisible(int type)
JDBC 2.0 Indicates whether updates made by others are visible. |
boolean |
ownDeletesAreVisible(int type)
JDBC 2.0 Indicates whether a result set's own deletes are visible. |
boolean |
ownInsertsAreVisible(int type)
JDBC 2.0 Indicates whether a result set's own inserts are visible. |
boolean |
ownUpdatesAreVisible(int type)
JDBC 2.0 Indicates whether a result set's own updates are visible. |
boolean |
storesLowerCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case? A JDBC CompliantTM driver will always return false. |
boolean |
storesLowerCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case? A JDBC CompliantTM driver will always return false. |
boolean |
storesMixedCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case insensitiveand store them in mixed case? A JDBC CompliantTM driver will always return false. |
boolean |
storesMixedCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case? A JDBC CompliantTM driver will always return false. |
boolean |
storesUpperCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case? A JDBC CompliantTM driver will always return false. |
boolean |
storesUpperCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case? A JDBC CompliantTM driver will always return false. |
boolean |
supportsAlterTableWithAddColumn()
Is "ALTER TABLE" with add column supported? |
boolean |
supportsAlterTableWithDropColumn()
Is "ALTER TABLE" with drop column supported? |
boolean |
supportsANSI92EntryLevelSQL()
Is the ANSI92 entry level SQL grammar supported? All JDBC CompliantTM drivers must return true. |
boolean |
supportsANSI92FullSQL()
Is the ANSI92 full level SQL grammar supported? |
boolean |
supportsANSI92IntermediateSQL()
Is the ANSI92 intermediate level SQL grammar supported? |
boolean |
supportsBatchUpdates()
JDBC 2.0 Indicates whether the driver supports batch updates. |
boolean |
supportsCatalogsInDataManipulation()
Can a catalog name be used in a data manipulation statement? |
boolean |
supportsCatalogsInIndexDefinitions()
Can a catalog name be used in an index definition statement? |
boolean |
supportsCatalogsInPrivilegeDefinitions()
Can a catalog name be used in an index definition statement? |
boolean |
supportsCatalogsInProcedureCalls()
Can a catalog name be used in a procedure call statement? |
boolean |
supportsCatalogsInTableDefinitions()
Can a catalog name be used in a table definition statement? |
boolean |
supportsColumnAliasing()
Is column aliasing supported? If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required. |
boolean |
supportsConvert()
Is the CONVERT function between SQL types supported? |
boolean |
supportsConvert(int fromType,
int toType)
Is the CONVERT between the given SQL types supported? |
boolean |
supportsCoreSQLGrammar()
Is the ODBC Core SQL grammar supported? |
boolean |
supportsCorrelatedSubqueries()
Are correlated subqueries supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Are both data definition and data manipulation statements within a transaction supported? |
boolean |
supportsDataManipulationTransactionsOnly()
Are only data manipulation statements within a transaction supported? |
boolean |
supportsDifferentTableCorrelationNames()
If table correlation names are supported, are they restricted to be different from the names of the tables?. |
boolean |
supportsExpressionsInOrderBy()
Are expressions in "ORDER BY" lists supported? |
boolean |
supportsExtendedSQLGrammar()
Is the ODBC Extended SQL grammar supported? |
boolean |
supportsFullOuterJoins()
Are full nested outer joins supported? |
boolean |
supportsGroupBy()
Is some form of "GROUP BY" clause supported? |
boolean |
supportsGroupByBeyondSelect()
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT? |
boolean |
supportsGroupByUnrelated()
Can a "GROUP BY" clause use columns not in the SELECT? |
boolean |
supportsIntegrityEnhancementFacility()
Is the SQL Integrity Enhancement Facility supported? |
boolean |
supportsLikeEscapeClause()
Is the escape character in "LIKE" clauses supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsLimitedOuterJoins()
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.) |
boolean |
supportsMinimumSQLGrammar()
Is the ODBC Minimum SQL grammar supported? All JDBC CompliantTM drivers must return true. |
boolean |
supportsMixedCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC CompliantTM driver will always return false. |
boolean |
supportsMixedCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC CompliantTM driver will always return true. |
boolean |
supportsMultipleResultSets()
Are multiple ResultSets from a single execute supported? |
boolean |
supportsMultipleTransactions()
Can we have multiple transactions open at once (on different connections)? |
boolean |
supportsNonNullableColumns()
Can columns be defined as non-nullable? A JDBC CompliantTM driver always returns true. |
boolean |
supportsOpenCursorsAcrossCommit()
Can cursors remain open across commits? |
boolean |
supportsOpenCursorsAcrossRollback()
Can cursors remain open across rollbacks? |
boolean |
supportsOpenStatementsAcrossCommit()
Can statements remain open across commits? |
boolean |
supportsOpenStatementsAcrossRollback()
Can statements remain open across rollbacks? |
boolean |
supportsOrderByUnrelated()
Can an "ORDER BY" clause use columns not in the SELECT statement? |
boolean |
supportsOuterJoins()
Is some form of outer join supported? |
boolean |
supportsPositionedDelete()
Is positioned DELETE supported? |
boolean |
supportsPositionedUpdate()
Is positioned UPDATE supported? |
boolean |
supportsResultSetConcurrency(int type,
int concur)
JDBC 2.0 Does the database support the concurrency type in combination with the given result set type? |
boolean |
supportsResultSetType(int type)
JDBC 2.0 Does the database support the given result set type? |
boolean |
supportsSchemasInDataManipulation()
Can a schema name be used in a data manipulation statement? |
boolean |
supportsSchemasInIndexDefinitions()
Can a schema name be used in an index definition statement? |
boolean |
supportsSchemasInPrivilegeDefinitions()
Can a schema name be used in a privilege definition statement? |
boolean |
supportsSchemasInProcedureCalls()
Can a schema name be used in a procedure call statement? |
boolean |
supportsSchemasInTableDefinitions()
Can a schema name be used in a table definition statement? |
boolean |
supportsSelectForUpdate()
Is SELECT for UPDATE supported? |
boolean |
supportsStoredProcedures()
Are stored procedure calls using the stored procedure escape syntax supported? |
boolean |
supportsSubqueriesInComparisons()
Are subqueries in comparison expressions supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsSubqueriesInExists()
Are subqueries in 'exists' expressions supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsSubqueriesInIns()
Are subqueries in 'in' statements supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsSubqueriesInQuantifieds()
Are subqueries in quantified expressions supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsTableCorrelationNames()
Are table correlation names supported? A JDBC CompliantTM driver always returns true. |
boolean |
supportsTransactionIsolationLevel(int level)
Does this database support the given transaction isolation level? |
boolean |
supportsTransactions()
Are transactions supported? If not, invoking the method commit is a noop and the isolation level is TRANSACTION_NONE. |
boolean |
supportsUnion()
Is SQL UNION supported? |
boolean |
supportsUnionAll()
Is SQL UNION ALL supported? |
boolean |
updatesAreDetected(int type)
JDBC 2.0 Indicates whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated. |
boolean |
usesLocalFilePerTable()
Does the database use a file for each table? |
boolean |
usesLocalFiles()
Does the database store tables in a local file? |
| Methods inherited from class java.lang.Object |
clone,
equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
| Constructor Detail |
public RealSQLDatabaseMetaData(RealSQLConnection con,
int traceFlags)
throws RealSQLException
con - a Connection object.traceFlags - the type of events that to be logged.| Method Detail |
protected void finalize()
throws java.sql.SQLException
public boolean allProceduresAreCallable()
throws java.sql.SQLException
public boolean allTablesAreSelectable()
throws java.sql.SQLException
public boolean deletesAreDetected(int type)
throws java.sql.SQLException
type, - i.e. ResultSet.TYPE_XXX
public java.lang.String getURL()
throws java.sql.SQLException
public java.lang.String getUserName()
throws java.sql.SQLException
public boolean isReadOnly()
throws java.sql.SQLException
public boolean nullsAreSortedHigh()
throws java.sql.SQLException
public boolean nullsAreSortedLow()
throws java.sql.SQLException
public boolean nullsAreSortedAtStart()
throws java.sql.SQLException
public boolean nullsAreSortedAtEnd()
throws java.sql.SQLException
public java.lang.String getDatabaseProductName()
throws java.sql.SQLException
public java.lang.String getDatabaseProductVersion()
throws java.sql.SQLException
public java.lang.String getDriverName()
throws java.sql.SQLException
public java.lang.String getDriverVersion()
throws java.sql.SQLException
public int getDriverMajorVersion()
public int getDriverMinorVersion()
public boolean usesLocalFiles()
throws java.sql.SQLException
public boolean usesLocalFilePerTable()
throws java.sql.SQLException
public boolean supportsMixedCaseIdentifiers()
throws java.sql.SQLException
public boolean storesUpperCaseIdentifiers()
throws java.sql.SQLException
public boolean storesLowerCaseIdentifiers()
throws java.sql.SQLException
public boolean storesMixedCaseIdentifiers()
throws java.sql.SQLException
public boolean supportsMixedCaseQuotedIdentifiers()
throws java.sql.SQLException
public boolean storesUpperCaseQuotedIdentifiers()
throws java.sql.SQLException
public boolean storesLowerCaseQuotedIdentifiers()
throws java.sql.SQLException
public boolean storesMixedCaseQuotedIdentifiers()
throws java.sql.SQLException
public java.sql.Connection getConnection()
throws java.sql.SQLException
public java.lang.String getIdentifierQuoteString()
throws java.sql.SQLException
public java.lang.String getSQLKeywords()
throws java.sql.SQLException
public java.lang.String getNumericFunctions()
throws java.sql.SQLException
public java.lang.String getStringFunctions()
throws java.sql.SQLException
public java.lang.String getSystemFunctions()
throws java.sql.SQLException
public java.lang.String getTimeDateFunctions()
throws java.sql.SQLException
public java.lang.String getSearchStringEscape()
throws java.sql.SQLException
The '_' character represents any single character.
The '%' character represents any sequence of zero or more characters.
public java.lang.String getExtraNameCharacters()
throws java.sql.SQLException
public boolean supportsAlterTableWithAddColumn()
throws java.sql.SQLException
public boolean supportsAlterTableWithDropColumn()
throws java.sql.SQLException
public boolean supportsColumnAliasing()
throws java.sql.SQLException
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required. A JDBC CompliantTM driver always returns true.
public boolean nullPlusNonNullIsNull()
throws java.sql.SQLException
public boolean supportsConvert()
throws java.sql.SQLException
public boolean supportsConvert(int fromType,
int toType)
throws java.sql.SQLException
fromType - - the type to convert from.toType - - the type to convert to.
public boolean supportsTableCorrelationNames()
throws java.sql.SQLException
public boolean supportsDifferentTableCorrelationNames()
throws java.sql.SQLException
public boolean supportsExpressionsInOrderBy()
throws java.sql.SQLException
public boolean supportsOrderByUnrelated()
throws java.sql.SQLException
public boolean supportsGroupBy()
throws java.sql.SQLException
public boolean supportsGroupByUnrelated()
throws java.sql.SQLException
public boolean supportsGroupByBeyondSelect()
throws java.sql.SQLException
public boolean supportsLikeEscapeClause()
throws java.sql.SQLException
public boolean supportsMultipleResultSets()
throws java.sql.SQLException
public boolean supportsMultipleTransactions()
throws java.sql.SQLException
public boolean supportsNonNullableColumns()
throws java.sql.SQLException
public boolean supportsMinimumSQLGrammar()
throws java.sql.SQLException
public boolean supportsCoreSQLGrammar()
throws java.sql.SQLException
public boolean supportsExtendedSQLGrammar()
throws java.sql.SQLException
public boolean supportsANSI92EntryLevelSQL()
throws java.sql.SQLException
public boolean supportsANSI92IntermediateSQL()
throws java.sql.SQLException
public boolean supportsANSI92FullSQL()
throws java.sql.SQLException
public boolean supportsIntegrityEnhancementFacility()
throws java.sql.SQLException
public boolean supportsOuterJoins()
throws java.sql.SQLException
public boolean supportsFullOuterJoins()
throws java.sql.SQLException
public boolean supportsLimitedOuterJoins()
throws java.sql.SQLException
public java.lang.String getSchemaTerm()
throws java.sql.SQLException
public java.lang.String getProcedureTerm()
throws java.sql.SQLException
public java.lang.String getCatalogTerm()
throws java.sql.SQLException
public boolean isCatalogAtStart()
throws java.sql.SQLException
public java.lang.String getCatalogSeparator()
throws java.sql.SQLException
public boolean supportsSchemasInDataManipulation()
throws java.sql.SQLException
public boolean supportsSchemasInProcedureCalls()
throws java.sql.SQLException
public boolean supportsSchemasInTableDefinitions()
throws java.sql.SQLException
public boolean supportsSchemasInIndexDefinitions()
throws java.sql.SQLException
public boolean supportsSchemasInPrivilegeDefinitions()
throws java.sql.SQLException
public boolean supportsCatalogsInDataManipulation()
throws java.sql.SQLException
public boolean supportsCatalogsInProcedureCalls()
throws java.sql.SQLException
public boolean supportsCatalogsInTableDefinitions()
throws java.sql.SQLException
public boolean supportsCatalogsInIndexDefinitions()
throws java.sql.SQLException
public boolean supportsCatalogsInPrivilegeDefinitions()
throws java.sql.SQLException
public boolean supportsPositionedDelete()
throws java.sql.SQLException
public boolean supportsPositionedUpdate()
throws java.sql.SQLException
public boolean supportsSelectForUpdate()
throws java.sql.SQLException
public boolean supportsStoredProcedures()
throws java.sql.SQLException
public boolean supportsSubqueriesInComparisons()
throws java.sql.SQLException
public boolean supportsSubqueriesInExists()
throws java.sql.SQLException
public boolean supportsSubqueriesInIns()
throws java.sql.SQLException
public boolean supportsSubqueriesInQuantifieds()
throws java.sql.SQLException
public boolean supportsCorrelatedSubqueries()
throws java.sql.SQLException
public boolean supportsUnion()
throws java.sql.SQLException
public boolean supportsUnionAll()
throws java.sql.SQLException
public boolean supportsOpenCursorsAcrossCommit()
throws java.sql.SQLException
public boolean supportsOpenCursorsAcrossRollback()
throws java.sql.SQLException
public boolean supportsOpenStatementsAcrossCommit()
throws java.sql.SQLException
public boolean supportsOpenStatementsAcrossRollback()
throws java.sql.SQLException
public int getMaxBinaryLiteralLength()
throws java.sql.SQLException
public int getMaxCharLiteralLength()
throws java.sql.SQLException
public int getMaxColumnNameLength()
throws java.sql.SQLException
public int getMaxColumnsInGroupBy()
throws java.sql.SQLException
public int getMaxColumnsInIndex()
throws java.sql.SQLException
public int getMaxColumnsInOrderBy()
throws java.sql.SQLException
public int getMaxColumnsInSelect()
throws java.sql.SQLException
public int getMaxColumnsInTable()
throws java.sql.SQLException
public int getMaxConnections()
throws java.sql.SQLException
public int getMaxCursorNameLength()
throws java.sql.SQLException
public int getMaxIndexLength()
throws java.sql.SQLException
public int getMaxSchemaNameLength()
throws java.sql.SQLException
public int getMaxProcedureNameLength()
throws java.sql.SQLException
public int getMaxCatalogNameLength()
throws java.sql.SQLException
public int getMaxRowSize()
throws java.sql.SQLException
public boolean doesMaxRowSizeIncludeBlobs()
throws java.sql.SQLException
public int getMaxStatementLength()
throws java.sql.SQLException
public int getMaxStatements()
throws java.sql.SQLException
public int getMaxTableNameLength()
throws java.sql.SQLException
public int getMaxTablesInSelect()
throws java.sql.SQLException
public int getMaxUserNameLength()
throws java.sql.SQLException
public int getDefaultTransactionIsolation()
throws java.sql.SQLException
public boolean supportsTransactions()
throws java.sql.SQLException
public boolean supportsTransactionIsolationLevel(int level)
throws java.sql.SQLException
level - - the values are defined in java.sql.Connection
public boolean supportsDataDefinitionAndDataManipulationTransactions()
throws java.sql.SQLException
public boolean supportsDataManipulationTransactionsOnly()
throws java.sql.SQLException
public boolean dataDefinitionCausesTransactionCommit()
throws java.sql.SQLException
public boolean dataDefinitionIgnoredInTransactions()
throws java.sql.SQLException
public java.sql.ResultSet getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
throws java.sql.SQLException
Gets a description of the stored procedures available in a catalog. Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschemaPattern - a schema name pattern; "" retrieves those without a
schemaprocedureNamePattern - a procedure name pattern
public java.sql.ResultSet getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
Gets a description of a catalog's stored procedure parameters and result columns. Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschemaPattern - a schema name pattern; "" retrieves those without a
schemaprocedureNamePattern - a procedure name patterncolumnNamePattern - a column name pattern
public java.sql.ResultSet getTables(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
java.lang.String[] types)
throws java.sql.SQLException
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name
from the selection criteriaschemaPattern - a schema name pattern; "" retrieves those without a
schematableNamePattern - a table name patterntypes - a list of table types to include; null returns all types
public java.sql.ResultSet getSchemas()
throws java.sql.SQLException
public java.sql.ResultSet getCatalogs()
throws java.sql.SQLException
public java.sql.ResultSet getTableTypes()
throws java.sql.SQLException
public java.sql.ResultSet getColumns(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
java.lang.String columnName)
throws java.sql.SQLException
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschemaPattern - a schema name pattern; "" retrieves those without
a schematableNamePattern - a table name patterncolumnNamePattern - a column name pattern
public java.sql.ResultSet getColumnPrivileges(java.lang.String ct,
java.lang.String sch,
java.lang.String tn,
java.lang.String cn)
throws java.sql.SQLException
Gets a description of the access rights for a table's columns. Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriacatalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table namecolumnNamePattern - a column name pattern
public java.sql.ResultSet getTablePrivileges(java.lang.String ct,
java.lang.String sch,
java.lang.String tn)
throws java.sql.SQLException
Gets a description of the access rights for each table available in a catalog. Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.)
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriacatalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriacataloga - catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschemaPattern - a schema name pattern; "" retrieves those without
a schematableNamePattern - a table name pattern
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
int scope,
boolean nullable)
throws java.sql.SQLException
Reality ignores the value of the input parameters scope
and nullable (although they must be suplied), this is due
to the fact that Reality will always return bestRowSession
for the value of the SCOPE column in the result set, indicating that
the scope of the best row identifier is valid for the remainder of the
current session. Also, any columns that uniquely identify a row in
Reality cannot be NULL
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name
from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table namescope - ignored, use bestRowSession.nullable - ignored, no columns identifying a row are nullable.
public java.sql.ResultSet getVersionColumns(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName)
throws java.sql.SQLException
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriacatalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table name
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName)
throws java.sql.SQLException
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table name
public java.sql.ResultSet getImportedKeys(java.lang.String ct,
java.lang.String sch,
java.lang.String t)
throws java.sql.SQLException
Gets a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table name
public java.sql.ResultSet getExportedKeys(java.lang.String ct,
java.lang.String sch,
java.lang.String t)
throws java.sql.SQLException
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table name
public java.sql.ResultSet getCrossReference(java.lang.String pcat,
java.lang.String pschem,
java.lang.String ptable,
java.lang.String fcat,
java.lang.String fschem,
java.lang.String ftable)
throws java.sql.SQLException
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
primaryCatalog - a catalog name; "" retrieves those without
a catalog; null means drop catalog name from the selection criteriaprimarySchema - a schema name; "" retrieves those without a schemaprimaryTable - the table name that exports the keyforeignCatalog - a catalog name; "" retrieves those without
a catalog; null means drop catalog name from the selection criteriaforeignSchema - a schema name; "" retrieves those without a schemaforeignTable - the table name that imports the key
public java.sql.ResultSet getTypeInfo()
throws java.sql.SQLException
public java.sql.ResultSet getIndexInfo(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
boolean unique,
boolean approximate)
throws java.sql.SQLException
The input parameter approximate is ignored, this flag
impacts on the values returned for the CARDINALITY and PAGES in the
result set. Reality is not currently capable of providing this
information and therefore returns a NULL value for both these columns.
The result set is ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschema - a schema name; "" retrieves those without a schematable - a table nameunique - when true, return only indices for unique values;
when false, return indices regardless of whether unique or notapproximate - ignored, see comments above.
public java.sql.ResultSet getUDTs(java.lang.String catalog,
java.lang.String schema,
java.lang.String tn,
int[] types)
throws java.sql.SQLException
JDBC 2.0 Gets a description of the user-defined types defined in a particular schema. Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
catalog - a catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteriaschemaPattern - a schema name pattern; "" retrieves those without a
schematypeNamePattern - a type name pattern; may be a fully-qualified
nametypes - a list of user-named types to include (JAVA_OBJECT,
STRUCT, or DISTINCT); null returns all types
public boolean insertsAreDetected(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean othersDeletesAreVisible(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean othersInsertsAreVisible(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean othersUpdatesAreVisible(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean ownDeletesAreVisible(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean ownInsertsAreVisible(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean ownUpdatesAreVisible(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
public boolean supportsBatchUpdates()
throws java.sql.SQLException
public boolean supportsResultSetConcurrency(int type,
int concur)
throws java.sql.SQLException
type - defined in java.sql.ResultSetconcurrency - type defined in java.sql.ResultSet
public boolean supportsResultSetType(int type)
throws java.sql.SQLException
type - defined in java.sql.ResultSet
public boolean updatesAreDetected(int type)
throws java.sql.SQLException
result - set type, i.e. ResultSet.TYPE_XXX
|
|||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||